let ejs = require("ejs");
let mysql = require('mysql');
let server = require('express')();

server.all("*", function(req, res, next) {
    //设置允许跨域的域名，*代表允许任意域名跨域
    res.header("Access-Control-Allow-Origin", "*");
    //允许的header类型
    res.header("Access-Control-Allow-Headers", "content-type");
    //跨域允许的请求方式 
    res.header("Access-Control-Allow-Methods", "DELETE,PUT,POST,GET,OPTIONS");
    if (req.method.toLowerCase() == 'options')
        res.send(200); //让options尝试请求快速结束
    else
        next();
})

let sql = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '123456',
    database: 'qiyezhan',
    timezone: "08:00"
});
// // 尝试连接
sql.connect();

// 案例列表
server.get("/anlist", function(request, response) {
        sql.query(`SELECT * FROM anlist`, function(error, data) {
            if (error) {
                console.log(error)
                return;
            }

            response.end(JSON.stringify(data));

        })
    })
    // 案例详情
server.get("/anli", function(request, response) {
        let id = request.query.id;
        sql.query(`SELECT * FROM anli WHERE id=${id}`, function(error, data) {
            if (error) {
                console.log(error)
                return;
            }

            response.end(JSON.stringify(data));

        })
    })
    // 解决方案列表
server.get("/falist", function(request, response) {
        sql.query(`SELECT * FROM falist`, function(error, data) {
            if (error) {
                console.log(error)
                return;
            }

            response.end(JSON.stringify(data));

        })
    })
    // 解决方案详情
server.get("/fangan", function(request, response) {
    let id = request.query.id;
    sql.query(`SELECT * FROM fangan WHERE id=${id}`, function(error, data) {
        if (error) {
            console.log(error)
            return;
        }

        response.end(JSON.stringify(data));

    })
})
server.listen(81);